2016-02-01 - 23959 - Service Request - Service Level Year End Loading #SalesDistribution
Service Request
5287 - Service Level Year End Loading
Problem Summary
Need to reload the Futures Infocube(ZSD_ORDER) & Service level infocube(ZSDC_SSL).
Admin Info
Purpose
|
Service Level & Futures cube Year End data loading
|
Requested by
|
Mark Harris
|
Issue Date
|
01-02-2016
|
Resolved by
|
Naveen G
|
Resolved Date
|
01-02-2016
|
Document Status
|
Complete
|
Detailed Problem Description
The DTP filter conditions in Service level source(ZSDC_SSL) are hard coded to load data for 2014 & 2015 fiscal years daily. As the year gets drifted to 2016 these filter conditions for Historical & current requests need to be changed & data needs to be reloaded. Similarly for the Futures infocube(ZSD_ORDER) should contain data only for current & previous years only. As the year gets drifted to 2016, the infocube needs to be cleared & reloaded.
Solution Analysis and Recommendations
1. Need to change the filter condtions for Historical & Current data requests for both Global & Regioanl sources.
2. Need to delete the data requests in infocubes ZSDC_SSL, ZSD_ORDER, Z_SSL02, Z_SSL03 and Z_SSL05.
3. Need to reload the infocubes ZSDC_SSL, ZSD_ORDER, Z_SSL02, Z_SSL03 and Z_SSL05.
Resolution
Once reloaded, the data in Service level & Futures info cubes will be available for FY 2016.
Release Information
None